﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ZhangWuCX.aspx.cs" Inherits="Web.Pages.QuShui.DiXiaS.ChaXunGL.ZhangWuCX" Theme="Default"%>


<%@ Register Assembly="DevExpress.Web.v15.2, Version=15.2.9.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>
<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title></title>
    <script src="../../../../JS/jquery.js" type="text/javascript"></script>
    <script src="../../../../JS/AddEditCancel.js" type="text/javascript"></script>
    <link href="../../../../css/inputBgColor.css" rel="stylesheet" />
   
    <script type="text/javascript">
       

        //tab页签改变
        function TabChange(obj) {
            var index = obj.GetActiveTabIndex();
            if (index == 1 || index == 2 || index == 3) {
                cmbZhangWuY2.SetEnabled(true);
                cmbZhangWuM2.SetEnabled(true);
            }
            else {
                //cmbZhangWuY2.SetText('');
                //cmbZhangWuM2.SetText('');
                cmbZhangWuY2.SetEnabled(false);
                cmbZhangWuM2.SetEnabled(false);
            }
        }

        function textchange1(obj) {
            cmbZhangWuY2.SetText(cmbZhangWuY.GetText());
        }

        function textchange2(obj) {
            cmbZhangWuM2.SetText(cmbZhangWuM.GetText());
        }
    </script>
    <style type="text/css">
        body, html {
            padding: 0;
            margin: 0;
        }
    </style>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <div class="tabletitle1" align="center">
            账务查询
        </div>
        <dx:ASPxHiddenField ID="HiddenListValue" ClientInstanceName="HiddenListValue" runat="server"></dx:ASPxHiddenField>
        <dx:ASPxCallback ID="ASPxCallbackControl" ClientInstanceName="ASPxCallbackControl" ClientSideEvents-CallbackComplete="function(s,e){CallBack(e.result);}" OnCallback="ASPxCallbackControl_Callback" runat="server"></dx:ASPxCallback>
        <asp:UpdatePanel ID="updatePanel1" runat="server">
            <ContentTemplate>
                <div style="border: 1px solid #d0e4fe; text-align: right;">
                    <table>
                        <tr>
                            <td style="width: 70px"><span style="font-size: 12px;">账务年月：</span></td>
                            <td style="width: 7%;">
                                <asp:Panel runat="server" ID="Panel1">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuY" Width="100%">
                                        <Items>
                                        </Items>
                                         <ClientSideEvents  TextChanged="function(s,e){textchange1(s);}"/>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;">
                                <asp:Panel runat="server" ID="Panel2">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuM" Width="90%">
                                        <Items>
                                            <dx:ListEditItem Text="全部" Value="0" />
                                        </Items>
                                        <ClientSideEvents  TextChanged="function(s,e){textchange2(s);}"/>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width:3px;text-align:center;">&nbsp;-&nbsp;</td>
                            <td style="width: 7%;">
                                <asp:Panel runat="server" ID="Panel111">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuY2" Width="100%" ClientEnabled="false">
                                        <Items>
                                            <%--<dx:ListEditItem Text=" " Value="" />--%>
                                        </Items>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td>
                            <td style="width: 6%;">
                                <asp:Panel runat="server" ID="Panel22">
                                    <dx:ASPxComboBox runat="server" ID="cmbZhangWuM2" Width="90%" ClientEnabled="false">
                                        <Items>
                                            <dx:ListEditItem Text="全部" Value="0" />
                                        </Items>
                                    </dx:ASPxComboBox>
                                </asp:Panel>
                            </td> 
                            <td style="width:7%;"><span style="font-size: 12px;">环内环外：</span></td>
                                <td>
                                    <asp:Panel runat="server" ID="Panel121">
                                        <dx:ASPxComboBox runat="server" ID="cmbHuanNeiHW" Width="60%" AutoPostBack="false">
                                            <Items>
                                                <dx:ListEditItem Text="" Value="0" />
                                                <dx:ListEditItem Text="外环线内" Value="1" />
                                                <dx:ListEditItem Text="外环线外" Value="2" />
                                            </Items>
                                        </dx:ASPxComboBox>
                                    </asp:Panel>
                                </td>
                                <td style="width:6%;"><span style="font-size: 12px;">行政区：</span></td>
                                <td>
                                    <asp:Panel runat="server" ID="Panel222">
                                        <dx:ASPxComboBox runat="server" ID="cmbXingZhengQ" Width="60%">
                                            <Items>
                                                <dx:ListEditItem Text="全部" Value="0" Selected="true"  />
                                            </Items>
                                        </dx:ASPxComboBox>
                                    </asp:Panel>
                                </td> 
                            <td>&nbsp;&nbsp;</td>
                            <td>
                                 <dx:ASPxLoadingPanel runat="server" ID="LoadPanel" ClientInstanceName="LoadPanel" Text="正在查询"></dx:ASPxLoadingPanel>
                                <dx:ASPxButton runat="server" ID="btnChaXun" Text="查询" OnClick="btnChaXun_Click">
                                    <ClientSideEvents Click="function(s,e){LoadPanel.Show();}" />
                                </dx:ASPxButton>
                            </td>
                             <td>
                                    <dx:ASPxButton ID="btnExport2" runat="server"  Text="导出EXCEL" >
                                        <ClientSideEvents Click="function(s,e){btnExport.OnClick();}"/>
                                    </dx:ASPxButton>
                                </td>  
                        </tr>
                    </table>
                    <hr />
                   <table>
                       <tr>
                           <td style="text-align:right;">
                               <dx:ASPxCheckBox runat="server" ID="chkYongHuH" Checked="false" Text="用户号" Width="60px" ClientInstanceName="chkYongHuH"></dx:ASPxCheckBox>
                               <%--<dx:ASPxRadioButton runat="server" ID="chkYongHuH" Checked="false" Text="用户号" ClientInstanceName="chkYongHuH" ></dx:ASPxRadioButton>--%>
                           </td>
                           <td style="width: 8%;text-align:left;">
                               <dx:ASPxTextBox runat="server" ID="txtYongHuH" Width="90%">
                                   <ClientSideEvents GotFocus="function(s,e){chkYongHuH.SetChecked(true);}" />
                               </dx:ASPxTextBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxCheckBox runat="server" ID="chkYongHuM" Text="用户名"  ClientInstanceName="chkYongHuM"></dx:ASPxCheckBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxTextBox runat="server" ID="txtYongHuM" Width="95%">
                                   <ClientSideEvents GotFocus="function(s,e){chkYongHuM.SetChecked(true);}" />
                               </dx:ASPxTextBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxCheckBox runat="server" ID="rabQuShuiYT" Text="取水用途"  ClientInstanceName="rabQuShuiYT"></dx:ASPxCheckBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxComboBox ID="cmbQuShuiYT" ClientInstanceName="cmbQuShuiYT" runat="server" Width="95%">
                                   <ClientSideEvents GotFocus="function(s,e){rabQuShuiYT.SetChecked(true);}" />
                               </dx:ASPxComboBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxCheckBox runat="server" ID="rabHangYeLX" Text="行业分类"  ClientInstanceName="rabHangYeLX"></dx:ASPxCheckBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxComboBox ID="cmbHangYeLX" ClientInstanceName="cmbHangYeLX" runat="server" ValueType="System.String" Width="95%">
                              
                                   <ClientSideEvents GotFocus="function(s,e){rabHangYeLX.SetChecked(true);}" />
                               </dx:ASPxComboBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxCheckBox runat="server" ID="rabGuanLiBM" Text="主管部门"  ClientInstanceName="rabGuanLiBM"></dx:ASPxCheckBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxComboBox ID="cbmGuanLiBM" ClientInstanceName="cbmGuanLiBM" runat="server" Width="95%">
                                   <ClientSideEvents GotFocus="function(s,e){rabGuanLiBM.SetChecked(true);}" />
                               </dx:ASPxComboBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxCheckBox runat="server" ID="rabShuiLiangYM" Text="水量年月" ClientInstanceName="rabShuiLiangYM"></dx:ASPxCheckBox>
                           </td>
                           <td style="width: 5%">
                               <dx:ASPxComboBox ID="cmbSLYM2Tab1" ClientInstanceName="cmbSLYM2Tab1" runat="server" Width="100%">
                                   <Items>
                                       <dx:ListEditItem Text="=" Value="1" />
                                       <dx:ListEditItem Text=">" Value="2" />
                                       <dx:ListEditItem Text=">=" Value="3" />
                                       <dx:ListEditItem Text="<" Value="4" />
                                       <dx:ListEditItem Text="<=" Value="5" />
                                       <dx:ListEditItem Text="<>" Value="6" />
                                   </Items>
                                   <ClientSideEvents GotFocus="function(s,e){rabShuiLiangYM.SetChecked(true);}" />
                               </dx:ASPxComboBox>
                           </td>
                           <td style="width: 8%;">
                               <dx:ASPxTextBox runat="server" ID="txtShuiLiangYM" Width="100%" ClientInstanceName="txtShuiLiangYM">
                                   <ClientSideEvents KeyUp="function(s,e){inputNum(s);}" GotFocus="function(s,e){rabShuiLiangYM.SetChecked(true);}" />
                               </dx:ASPxTextBox>
                           </td>
                       </tr>
                   </table>
                </div>
                <div>
                    <dx:ASPxPageControl ID="ASPxPageControl1" ClientInstanceName="ASPxPageControl1" runat="server" ActiveTabIndex="0" Width="98%" AutoPostBack="false">
                        <ClientSideEvents  ActiveTabChanged="function(s,e){TabChange(s);}"/>
                        <TabPages>
                            <dx:TabPage Text="本期信息">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div style=" height: 30px; width:80%;">
                                            <table>
                                                <tr>
                                                    <td style="width:6%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabJinETab1" Text="金额"  ClientInstanceName="rabJinETab1"></dx:ASPxCheckBox>
                                                    </td>
                                                    <td style="width:10%">
                                                        <dx:ASPxComboBox ID="cmbJinE1Tab1" ClientInstanceName="cmbJinE1Tab1" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="" Value="0" />
                                                                <dx:ListEditItem Text="初开金额" Value="1" />
                                                                <dx:ListEditItem Text="实收金额" Value="2" />
                                                                <dx:ListEditItem Text="欠费调整" Value="3" />
                                                                <dx:ListEditItem Text="欠费 " Value="4" />
                                                                <dx:ListEditItem Text="多收" Value="5" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab1.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width:5%">
                                                        <dx:ASPxComboBox ID="cmbJinE2Tab1" ClientInstanceName="cmbJinE2Tab1" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="=" Value="1" />
                                                                <dx:ListEditItem Text=">" Value="2" />
                                                                <dx:ListEditItem Text=">=" Value="3" />
                                                                <dx:ListEditItem Text="<" Value="4" />
                                                                <dx:ListEditItem Text="<=" Value="5" />
                                                                <dx:ListEditItem Text="<>" Value="6" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab1.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width: 10%">
                                                        <dx:ASPxTextBox ID="txtJinETab1" ClientInstanceName="txtJinETab1" runat="server" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab1.SetChecked(true);}" KeyUp="function(s,e){inputFloat(s);}" />
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                    <td style="width: 6%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabShuiJiaTab1" Text="水价"  ClientInstanceName="rabShuiJiaTab1"></dx:ASPxCheckBox>
                                                    </td>
                                                    <td style="width: 5%">
                                                        <dx:ASPxComboBox ID="cmbShuiJiaTab1" ClientInstanceName="cmbShuiJiaTab1" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="=" Value="1" />
                                                                <dx:ListEditItem Text=">" Value="2" />
                                                                <dx:ListEditItem Text=">=" Value="3" />
                                                                <dx:ListEditItem Text="<" Value="4" />
                                                                <dx:ListEditItem Text="<=" Value="5" />
                                                                <dx:ListEditItem Text="<>" Value="6" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabShuiJiaTab1.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width: 10%">
                                                        <dx:ASPxTextBox ID="txtShuiJia" ClientInstanceName="txtShuiJia" runat="server" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rabShuiJiaTab1.SetChecked(true);}" KeyUp="function(s,e){inputFloat(s);}"/>
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                     <td style="width:8%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabQianFeiTab1" Text="欠费"  ClientInstanceName="rabQianFeiTab1"></dx:ASPxCheckBox>
                                                    </td> 
                                                </tr>
                                            </table>
                                        </div>
                                        <div style="border: 1px solid #d0e4fe;">

                                            <div>
                                                <dx:ASPxGridView ID="gvGridTab1" ClientInstanceName="gvGridTab1" runat="server" AutoGenerateColumns="False"
                                                    KeyFieldName="S_YONGHUH" EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="300">
                                                        </dx:GridViewDataTextColumn>
                                                         <dx:GridViewDataTextColumn FieldName="LX" Caption="费用类型" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_ZWYM" Caption="开帐年月" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="KZJE" Caption="初开金额" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="SSJE" Caption="实收金额" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="QFTZ" Caption="欠费调整" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="QF" Caption="欠费" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="USERNAME" Caption="业务员" Width="70" >
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="HSL" Caption="回收率(%)" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="SK_CK" Caption="实收/初开" Width="70">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="DS" Caption="多收" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_SHUIJIA" Caption="水价" Width="70" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="KZSL" Caption="开帐水量" Width="70" >
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_KAIZHANGRQ" Caption="开帐日期" Width="80" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="SFBZ" Caption="收费标准" Width="80" >
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>

                                                    <Settings VerticalScrollBarMode="Visible" HorizontalScrollBarMode="Auto" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" FirstPageButton-Visible="true" />
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(295,gvGridTab1);}" />
                                                    <%-- <ClientSideEvents FocusedRowChanged="function(s,e){rowClick();}" />--%>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">初开总额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtKaiZhangJEtab1" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">实收总额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtShiShouJEtab1" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">调整总额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtHeXiaoJEtab1" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                             <td style="width: 5%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab1" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">欠费总额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtQianFeitab1" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">多收总额：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtDuoShoutab1" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 6%;"><span style="font-size: 12px;">开帐水量：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtKaiZhangSLtab1" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>

                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="本月到账">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 6%">
                                                            <dx:ASPxCheckBox runat="server" ID="rabJinETab2" Text="到账金额" ClientInstanceName="rabJinETab2"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 5%">
                                                            <dx:ASPxComboBox ID="cmbJinE2Tab2" ClientInstanceName="cmbJinE2Tab2" runat="server" Width="100%">
                                                                <Items>
                                                                    <dx:ListEditItem Text="" Value="0" />
                                                                    <dx:ListEditItem Text="=" Value="1" />
                                                                    <dx:ListEditItem Text=">" Value="2" />
                                                                    <dx:ListEditItem Text=">=" Value="3" />
                                                                    <dx:ListEditItem Text="<" Value="4" />
                                                                    <dx:ListEditItem Text="<=" Value="5" />
                                                                    <dx:ListEditItem Text="<>" Value="6" />
                                                                </Items>
                                                                <ClientSideEvents GotFocus="function(s,e){rabJinETab2.SetChecked(true);}" />
                                                            </dx:ASPxComboBox>
                                                        </td>
                                                        <td style="width: 10%">
                                                            <dx:ASPxTextBox ID="txtJinETab2" ClientInstanceName="txtJinETab2" runat="server" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rabJinETab2.SetChecked(true);}"  KeyUp="function(s,e){inputFloat(s);}"/>
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnDaoZhangFLtab2" Text="到账分类" ClientInstanceName="rbnDaoZhangFLtab2"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <asp:Panel runat="server" ID="Panel4">
                                                                <dx:ASPxComboBox runat="server" ID="cmbChaoBiaoBMtab2" Width="90%" AutoPostBack="true">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="本月到帐" Value="1" />
                                                                        <dx:ListEditItem Text="旧欠到帐" Value="2" />
                                                                        <dx:ListEditItem Text="本月托收到帐" Value="3" />
                                                                        <dx:ListEditItem Text="本月非托收到帐" Value="4" />
                                                                        <dx:ListEditItem Text="旧欠托收" Value="5" />
                                                                        <dx:ListEditItem Text="旧欠初托收" Value="6" />
                                                                        <dx:ListEditItem Text="旧欠重托收" Value="7" />
                                                                        <dx:ListEditItem Text="旧欠非托收到账" Value="8" />
                                                                        <dx:ListEditItem Text="托收到帐（全部）" Value="9" />
                                                                        <dx:ListEditItem Text="非托收到帐（全部）" Value="10" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnDaoZhangFLtab2.SetChecked(true);}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnShouFeiFStab2" Text="收费方式" ClientInstanceName="rbnShouFeiFStab2"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel31">
                                                                <dx:ASPxComboBox runat="server" ID="cmbShuiLiangYtab2" Width="90%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="99" />
                                                                        <dx:ListEditItem Text="本月托收" Value="0" />
                                                                        <dx:ListEditItem Text="旧欠托收" Value="2" />
                                                                        <dx:ListEditItem Text="现金支票付委" Value="5" />
                                                                        <dx:ListEditItem Text="现金" Value="1" />
                                                                        <dx:ListEditItem Text="支票" Value="3" />
                                                                        <dx:ListEditItem Text="付委" Value="4" />
                                                                        <%--<dx:ListEditItem Text="预收" Value="303" />--%>
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnShouFeiFStab2.SetChecked(true);}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <%--<td style="width: 6%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnFeiYongLXtab2" Text="费用类型" ClientInstanceName="rbnFeiYongLXtab2"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel11">
                                                                <dx:ASPxComboBox runat="server" ID="cmbFeiYongLXtab2" Width="90%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="" Value="0" />
                                                                        <dx:ListEditItem Text="常规" Value="1" />
                                                                        <dx:ListEditItem Text="加价" Value="2" />
                                                                        <dx:ListEditItem Text="补收" Value="3" />
                                                                        <dx:ListEditItem Text="采灌补收" Value="4" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnFeiYongLXtab2.SetChecked(true);}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>--%>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvGridTab2" ClientInstanceName="gvGridtab2" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH"
                                                    EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="80"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="200"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="FPHM" Caption="发票号码" Width="100"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="LX" Caption="费用类型" Width="80"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="60"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="DZYM" Caption="到账年月" Width="60"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_JINE" Caption="到账金额" Width="100" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="SFLX" Caption="收费类型" Width="80"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="USERNAME" Caption="业务员" Width="80"></dx:GridViewDataTextColumn>
                                                        <%--<dx:GridViewDataTextColumn FieldName="USERNAME2" Caption="操作员" Width=""></dx:GridViewDataTextColumn>--%>
                                                        <dx:GridViewDataTextColumn FieldName="TSPZ" Caption="托收凭证" Width="100"></dx:GridViewDataTextColumn>
                                                        <%--<dx:GridViewDataTextColumn FieldName="" Caption="类型" Width="100"></dx:GridViewDataTextColumn>--%>
                                                        <dx:GridViewDataTextColumn FieldName="KZYM" Caption="开账年月" Width="80"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="SL" Caption="到账水量" Width="100"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="DL" Caption="到账电量" Width="100"></dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUORQ" Caption="操作日期" PropertiesTextEdit-DisplayFormatString="{0:yyyy-MM-dd}" Width="85"></dx:GridViewDataTextColumn>

                                                    </Columns>
                                                    <Settings VerticalScrollBarMode="Visible" VerticalScrollableHeight="400" HorizontalScrollBarMode="Auto" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" AlwaysShowPager="true" FirstPageButton-Visible="true" />
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvGridtab2);}" />
                                                    <%--<Settings  VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />--%>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 150px; text-align:left;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab2" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            
                                                            <td style="width: 100px;"><span style="font-size: 12px;">到账金额合计：</span></td>
                                                            <td style="width: 180px;">
                                                                <dx:ASPxTextBox runat="server" ID="txtDaoZhangJEHZtab2" Width="100%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 20px;"><span style="font-size: 12px;">元</span></td>
                                                             <td style="">&nbsp;</td>
                                                            <td style="width:100px;"><span style="font-size: 12px;">到账水量合计：</span></td>
                                                            <td style="width: 180px;">
                                                                <dx:ASPxTextBox runat="server" ID="txtDaoZhangSLHZtab2" Width="100%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 50px;"><span style="font-size: 12px;">立方米</span></td>
                                                            <td style="">&nbsp;</td>
                                                             <td style="width: 100px;"><span style="font-size: 12px;">水资源费合计：</span></td>
                                                            <td style="width: 180px;">
                                                                <dx:ASPxTextBox runat="server" ID="txtSZYFtab2" Width="100%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                            <td style="width: 20px;"><span style="font-size: 12px;">元</span></td> 
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="退票"  >
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table style="width:50%;">
                                                    <tr>
                                                        <td style="width:100px;">
                                                            <dx:ASPxCheckBox runat="server" ID="rabJinETab3" Text="退票金额" ClientInstanceName="rabJinETab3"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width:60px;">
                                                            <dx:ASPxComboBox ID="cmbJinE2Tab3" ClientInstanceName="cmbJinE2Tab3" runat="server" Width="100%">
                                                                <Items>
                                                                    <dx:ListEditItem Text="=" Value="1" />
                                                                    <dx:ListEditItem Text=">" Value="2" />
                                                                    <dx:ListEditItem Text=">=" Value="3" />
                                                                    <dx:ListEditItem Text="<" Value="4" />
                                                                    <dx:ListEditItem Text="<=" Value="5" />
                                                                    <dx:ListEditItem Text="<>" Value="6" />
                                                                </Items>
                                                                <ClientSideEvents GotFocus="function(s,e){rabJinETab3.SetChecked(true);}" />
                                                            </dx:ASPxComboBox>
                                                        </td>
                                                        <td style="width:120px;">
                                                            <dx:ASPxTextBox ID="txtJinETab3" ClientInstanceName="txtJinETab3" runat="server" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rabJinETab3.SetChecked(true);}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td>
                                                            <dx:ASPxCheckBox runat="server" ID="chkSGtab3" Text="手工" Checked="false"></dx:ASPxCheckBox>
                                                        </td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvGridtab3" ClientInstanceName="gvGridtab3" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH"
                                                    EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="280">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="LX" Caption="费用类型" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TUIPIAORQ" Caption="退票年月" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_KAIZHANGJE" Caption="退票金额" Width="65" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_REASON" Caption="退票理由" Width="200">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KAIHUH" Caption="银行账号" Width="120">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KAIHUYH" Caption="开户银行" Width="180">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_KAIHUHM" Caption="开户户名" Width="200">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YEWUY" Caption="业务员" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_CAOZUOR" Caption="操作员" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_BIANHAO" Caption="账单编号" Width="100">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUORQ" Caption="操作日期" Width="80" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                        </dx:GridViewDataTextColumn>
                                                         <dx:GridViewDataTextColumn FieldName="I_SHUILIANG" Caption="退票水量" Width="100">
                                                        </dx:GridViewDataTextColumn>
                                                         <dx:GridViewDataTextColumn FieldName="SZYF" Caption="水资源费" Width="100" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                    <Settings VerticalScrollBarMode="Visible" VerticalScrollableHeight="400" HorizontalScrollBarMode="Auto" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" AlwaysShowPager="true" FirstPageButton-Visible="true" />
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvGridtab3);}" />
                                                    <%-- <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />--%>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab3" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width:10%;"><span style="font-size: 12px;">退票金额汇总：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiPiaoJEHZtab3" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                             <td style="width: 10%;"><span style="font-size: 12px;">退票水量汇总：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiPiaoSLHZtab3" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td> 
                                                              <td style="width: 10%;"><span style="font-size: 12px;">水资源费汇总：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtSZYFtab3" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>  
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="退款" >
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnTuiPiaoJEtab4" Text="退款金额"  ClientInstanceName="rbnTuiPiaoJEtab4"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <asp:Panel runat="server" ID="Panel5">
                                                                <dx:ASPxComboBox runat="server" ID="cbmTuiPiaoJEtab4" Width="80%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="=" Value="" />
                                                                        <dx:ListEditItem Text=">" Value="0" />
                                                                        <dx:ListEditItem Text=">=" Value="1" />
                                                                        <dx:ListEditItem Text="<" Value="1" />
                                                                        <dx:ListEditItem Text="<=" Value="1" />
                                                                        <dx:ListEditItem Text="<>" Value="1" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnTuiPiaoJEtab4.SetChecked(true);}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel6">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiPiaoJE2tab4" Width="90%">
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnTuiPiaoJEtab4.SetChecked(true);}" KeyUp="function(s,e){inputFloat(s);}"/>
                                                                </dx:ASPxTextBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnTuiKuanLEtab4" Text="退款类型"  ClientInstanceName="cbmTuiKuanLEtab4"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <asp:Panel runat="server" ID="Panel16">
                                                                <dx:ASPxComboBox runat="server" ID="cbmTuiKuanLEtab4" Width="90%">
                                                                     <Items>
                                                                        <dx:ListEditItem Text="收错退款" Value="1" />
                                                                        <dx:ListEditItem Text="多收退款" Value="2" />
                                                                        <dx:ListEditItem Text="调整退款" Value="3" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){cbmTuiKuanLEtab4.SetChecked(true);}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnPiWenHtab4" Text="批文号"  ClientInstanceName="rbnPiWenHtab4"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 9%">
                                                            <dx:ASPxTextBox runat="server" ID="txtPiWenHtab4" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnPiWenHtab4.SetChecked(true);}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 35%;">&nbsp;</td>
                                                       
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvGridtab4" ClientInstanceName="gvGridtab4" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH"
                                                    EnableCallBacks="true" ClientIDMode="AutoID" Settings-ShowVerticalScrollBar="true" Width="100%">
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="250">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_FEETYPE" Caption="费用类型" Width="90">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_TKYM" Caption="退款日期" Width="85" >
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="N_TKJE" Caption="退款金额" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TKTYPE" Caption="退款类型" Width="100">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YWY" Caption="业务员" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_LAIHANBH" Caption="批文号" Width="120">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_CAOZUOR" Caption="操作员" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUORQ" Caption="操作日期" Width="85" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                    <Settings VerticalScrollBarMode="Visible" VerticalScrollableHeight="400" HorizontalScrollBarMode="Auto" />
                                                    <SettingsPager Mode="EndlessPaging" PageSize="100" AlwaysShowPager="true" FirstPageButton-Visible="true" />
                                                    <Settings ShowFooter="True" />
                                                    <SettingsBehavior AllowFocusedRow="True"  ColumnResizeMode="Control" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvGridtab4);}" />
                                                    <%--<Settings  VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />--%>
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab4" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width: 8%;"><span style="font-size: 12px;">退款合计：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiKuanHJtab4" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                            </td>
                                                              <td style="width: 10%;"><span style="font-size: 12px;">退款水量合计：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtTuiKuanSLHJtab4" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td> 
                                                              <td style="width: 10%;"><span style="font-size: 12px;">水资源费合计：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtSZYFtab4" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>   
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                           <%-- <dx:TabPage Text="欠费调整">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <div style="border: 1px solid #d0e4fe;">
                                                <table>
                                                    <tr>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnHeXiaoJEtab5" Text="调整金额"  ClientInstanceName="rbnHeXiaoJEtab5"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 6%;">
                                                            <asp:Panel runat="server" ID="Panel17">
                                                                <dx:ASPxComboBox runat="server" ID="cbmHeXiaoJEtab5" Width="80%">
                                                                    <Items>
                                                                        <dx:ListEditItem Text="=" Value="" />
                                                                        <dx:ListEditItem Text=">" Value="0" />
                                                                        <dx:ListEditItem Text=">=" Value="1" />
                                                                        <dx:ListEditItem Text="<" Value="1" />
                                                                        <dx:ListEditItem Text="<=" Value="1" />
                                                                        <dx:ListEditItem Text="<>" Value="1" />
                                                                    </Items>
                                                                    <ClientSideEvents GotFocus="function(s,e){rbnHeXiaoJEtab5.SetChecked(true);}" />
                                                                </dx:ASPxComboBox>
                                                            </asp:Panel>
                                                        </td>
                                                        <td style="width: 7%;">
                                                            <dx:ASPxTextBox runat="server" ID="txtHeXiaoJEtab5" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnHeXiaoJEtab5.SetChecked(true);}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 8%;">
                                                            <dx:ASPxCheckBox runat="server" ID="rbnPiWenHtab5" Text="批文号"  ClientInstanceName="rbnPiWenHtab5"></dx:ASPxCheckBox>
                                                        </td>
                                                        <td style="width: 9%">
                                                            <dx:ASPxTextBox runat="server" ID="txtPiWenHtab5" Width="80%">
                                                                <ClientSideEvents GotFocus="function(s,e){rbnPiWenHtab5.SetChecked(true);}" />
                                                            </dx:ASPxTextBox>
                                                        </td>
                                                        <td style="width: 35%;">&nbsp;</td>
                                                       
                                                    </tr>
                                                </table>
                                            </div>
                                            <div>
                                                <dx:ASPxGridView ID="gvGridtab5" ClientInstanceName="gvGridtab5" runat="server" AutoGenerateColumns="False" KeyFieldName="ID" EnableCallBacks="false" Theme="Aqua1" Width="100%">
                                                    <Columns>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="320">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="" Caption="费用类型" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="80">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="" Caption="退款年月" Width="85">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="" Caption="退款金额" Width="85" PropertiesTextEdit-DisplayFormatString="0.00">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="" Caption="退款类型" Width="85">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="" Caption="批文号" Width="85">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_YWY" Caption="业务员" Width="85">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="S_TIAOZHENGY" Caption="操作员" Width="85">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="D_CAOZUOSJ" Caption="操作日期" Width="100" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd">
                                                        </dx:GridViewDataTextColumn>
                                                        <dx:GridViewDataTextColumn FieldName="ID" Caption="退款水量" Width="60">
                                                        </dx:GridViewDataTextColumn>
                                                    </Columns>
                                                    <ClientSideEvents Init="function(s,e){AdjustSize(265,gvGridtab5);}" />
                                                    <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                    <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />
                                                </dx:ASPxGridView>
                                            </div>
                                            <div style="margin-top: 20px;">
                                                <fieldset style="border: 1px solid #d0e4fe;">
                                                    <legend>总计</legend>
                                                    <table style="text-align: right; height: 30px; width: 100%;">
                                                        <tr>
                                                            <td style="width: 7%;">
                                                                <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab5" Text="共0条"></dx:ASPxLabel>
                                                            </td>
                                                            <td style="width: 50%;">&nbsp;</td>
                                                            <td style="width: 8%;"><span style="font-size: 12px;">欠费调整合计：</span></td>
                                                            <td style="width: 10%;">
                                                                <dx:ASPxTextBox runat="server" ID="txtQianFeiTZHJtab5" Width="80%" Enabled="false" HorizontalAlign="Right"></dx:ASPxTextBox>
                                                            </td>
                                                        </tr>
                                                    </table>
                                                </fieldset>
                                            </div>
                                        </div>
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>--%>
                            <dx:TabPage Text="多收" >
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <table style="width:40%;">
                                                <tr>
                                                    <td style="width: 6%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabJinETab6" Text="多收金额"  ClientInstanceName="rabJinETab6"></dx:ASPxCheckBox>
                                                    </td>
                                                    <td style="width: 5%">
                                                        <dx:ASPxComboBox ID="cmbJinE2Tab6" ClientInstanceName="cmbJinE2Tab6" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="=" Value="1" />
                                                                <dx:ListEditItem Text=">" Value="2" />
                                                                <dx:ListEditItem Text=">=" Value="3" />
                                                                <dx:ListEditItem Text="<" Value="4" />
                                                                <dx:ListEditItem Text="<=" Value="5" />
                                                                <dx:ListEditItem Text="<>" Value="6" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab6.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width: 10%">
                                                        <dx:ASPxTextBox ID="txtJinETab6" ClientInstanceName="txtJinETab6" runat="server" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab6.SetChecked(true);}" KeyUp="function(s,e){inputFloat(s);}"/>
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                        <dx:ASPxGridView ID="gvGridtab6" ClientInstanceName="gvGridtab6" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH" Theme="Aqua1" Width="100%">
                                            <Columns>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="80"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="200"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="LX" Caption="费用类型" Width="60"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_YM" Caption="水量年月" Width="70"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="RQ1" Caption="多收年月" Width="70"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="KZJE" Caption="应收金额" Width="100" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="DS" Caption="多收金额" Width="100" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="USERNAME" Caption="业务员" Width="100"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="CZY" Caption="操作员" Width="100"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="RQ2" Caption="操作日期" Width="90" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd"></dx:GridViewDataTextColumn>
                                            </Columns>
                                            <ClientSideEvents Init="function(s,e){AdjustSize(440,gvGridtab6);}" />
                                            <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                            <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                        </dx:ASPxGridView>
                                          <fieldset style="border: 1px solid #d0e4fe;">
                                              <legend>多收处理</legend>
                                              <dx:ASPxGridView ID="gvGrid2tab6" ClientInstanceName="gvGrid2tab6" runat="server" AutoGenerateColumns="False" KeyFieldName="" EnableCallBacks="true" Theme="Aqua1" Width="100%" OnCustomCallback="gvGrid2tab6_CustomCallback">
                                                  <Columns>
                                                      <dx:GridViewDataTextColumn FieldName="" Caption="类型" Width="100" HeaderStyle-HorizontalAlign="Center"></dx:GridViewDataTextColumn>
                                                      <dx:GridViewDataTextColumn FieldName="" Caption="转入年月" Width="100" HeaderStyle-HorizontalAlign="Center"></dx:GridViewDataTextColumn>
                                                      <dx:GridViewDataTextColumn FieldName="" Caption="金额" Width="150" HeaderStyle-HorizontalAlign="Center" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                      <dx:GridViewDataTextColumn FieldName="" Caption="处理日期" Width="100" HeaderStyle-HorizontalAlign="Center" PropertiesTextEdit-DisplayFormatString="yyyy-MM-dd"></dx:GridViewDataTextColumn>
                                                  </Columns>
                                                  <Settings VerticalScrollableHeight="100" VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                                  <SettingsBehavior ProcessFocusedRowChangedOnServer="true" />
                                              </dx:ASPxGridView>
                                          </fieldset>
                                        <fieldset style="border: 1px solid #d0e4fe;">
                                            <legend>汇总</legend>
                                            <table style="text-align: right; width:20%;">
                                                <tr>
                                                    <td style="width: 6%;"><span style="font-size: 12px;">多收金额汇总：</span></td>
                                                    <td style="width: 7%;">
                                                        <dx:ASPxTextBox runat="server" ID="txtDuoShouJEHZtab6" Enabled="false" HorizontalAlign="Right" Width="80%" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                            </table>
                                        </fieldset>
                                       
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            
                            <dx:TabPage Text="水资源费">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <table style="width:60%;">
                                                <tr>
                                                    <td style="width: 6%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabJinETab8" Text="水资源费"  ClientInstanceName="rabJinETab8"></dx:ASPxCheckBox>
                                                    </td>
                                                    <td style="width: 5%">
                                                        <dx:ASPxComboBox ID="cmbJinE2Tab8" ClientInstanceName="cmbJinE2Tab8" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="=" Value="1" />
                                                                <dx:ListEditItem Text=">" Value="2" />
                                                                <dx:ListEditItem Text=">=" Value="3" />
                                                                <dx:ListEditItem Text="<" Value="4" />
                                                                <dx:ListEditItem Text="<=" Value="5" />
                                                                <dx:ListEditItem Text="<>" Value="6" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab8.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width: 10%">
                                                        <dx:ASPxTextBox ID="txtJinETab8" ClientInstanceName="txtJinETab8" runat="server" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab8.SetChecked(true);}"  KeyUp="function(s,e){inputFloat(s);}"/>
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                    <td style="width: 8%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabShuiZiYFTab8" Text="水资源水价"  ClientInstanceName="rabShuiZiYFTab8"></dx:ASPxCheckBox>
                                                    </td>

                                                    <td style="width: 5%">
                                                        <dx:ASPxComboBox ID="cmbShuiZiYFTab8" ClientInstanceName="cmbShuiZiYFTab8" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="=" Value="1" />
                                                                <dx:ListEditItem Text=">" Value="2" />
                                                                <dx:ListEditItem Text=">=" Value="3" />
                                                                <dx:ListEditItem Text="<" Value="4" />
                                                                <dx:ListEditItem Text="<=" Value="5" />
                                                                <dx:ListEditItem Text="<>" Value="6" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabShuiZiYFTab8.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width: 10%">
                                                        <dx:ASPxTextBox ID="txtShuiZiYFTab8" ClientInstanceName="txtShuiZiYFTab8" runat="server" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rabShuiZiYFTab8.SetChecked(true);}" KeyUp="function(s,e){inputFloat(s);}"/>
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                        <dx:ASPxGridView ID="gvGridtab8" ClientInstanceName="gvGridtab8" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH" Theme="Aqua1" Width="100%">
                                            <Columns>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="10%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="25%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_SLYM" Caption="水量年月" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_KAIZHENGNY" Caption="开征年月" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_SHUIZIYF" Caption="水资源费" Width="10%" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_SHUIZIYSJ" Caption="水资源水价" Width="10%" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_CAOZUOR" Caption="操作员" Width="10%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="D_CAOZUORQ" Caption="操作日期" PropertiesTextEdit-DisplayFormatString="{0:yyyy-MM-dd}" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="I_KAIZHENGSL" Caption="开征水量" Width="10%"></dx:GridViewDataTextColumn>
                                            </Columns>
                                            <ClientSideEvents Init="function(s,e){AdjustSize(205,gvGridtab8);}" />
                                            <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                            <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                        </dx:ASPxGridView>
                                        <div>
                                            <table style="width:40%;">
                                                <tr>
                                                    <td style="width: 6%;"><span style="font-size: 12px;">水资源费总额：</span></td>
                                                    <td style="width: 10%;">
                                                        <dx:ASPxTextBox runat="server" ID="txtHeXiaoJEtab8" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                    </td>
                                                    <td style="width: 5%;">
                                                        <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab8" Text="共0条"></dx:ASPxLabel>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                          
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                            <dx:TabPage Text="补收">
                                <ContentCollection>
                                    <dx:ContentControl>
                                        <div>
                                            <table style="width:40%;">
                                                <tr>
                                                    <td style="width: 6%">
                                                        <dx:ASPxCheckBox runat="server" ID="rabJinETab9" Text="补收金额"  ClientInstanceName="rabJinETab9"></dx:ASPxCheckBox>
                                                    </td>
                                                    <td style="width: 5%">
                                                        <dx:ASPxComboBox ID="cmbJinE2Tab9" ClientInstanceName="cmbJinE2Tab9" runat="server" Width="100%">
                                                            <Items>
                                                                <dx:ListEditItem Text="=" Value="1" />
                                                                <dx:ListEditItem Text=">" Value="2" />
                                                                <dx:ListEditItem Text=">=" Value="3" />
                                                                <dx:ListEditItem Text="<" Value="4" />
                                                                <dx:ListEditItem Text="<=" Value="5" />
                                                                <dx:ListEditItem Text="<>" Value="6" />
                                                            </Items>
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab9.SetChecked(true);}" />
                                                        </dx:ASPxComboBox>
                                                    </td>
                                                    <td style="width: 10%">
                                                        <dx:ASPxTextBox ID="txtJinETab9" ClientInstanceName="txtJinETab9" runat="server" Width="80%">
                                                            <ClientSideEvents GotFocus="function(s,e){rabJinETab9.SetChecked(true);}" KeyUp="function(s,e){inputFloat(s);}"/>
                                                        </dx:ASPxTextBox>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div>
                                        <dx:ASPxGridView ID="gvGridtab9" ClientInstanceName="gvGridtab9" runat="server" AutoGenerateColumns="False" KeyFieldName="S_YONGHUH" Theme="Aqua1" Width="100%">
                                            <Columns>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUH" Caption="用户号" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_YONGHUM" Caption="用户名" Width="20%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="LX" Caption="补收类型" Width="8%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="N_JINE" Caption="补收金额" Width="8%" PropertiesTextEdit-DisplayFormatString="0.00"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_BUSHOURQ" Caption="补收日期" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="USERNAME" Caption="操作员" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="D_TIANJIARQ" Caption="操作日期" PropertiesTextEdit-DisplayFormatString="{0:yyyy-MM-dd}" Width="9%"></dx:GridViewDataTextColumn>
                                                <dx:GridViewDataTextColumn FieldName="S_BEIZHU" Caption="备注" Width="30%"></dx:GridViewDataTextColumn>
                                            </Columns>
                                            <ClientSideEvents Init="function(s,e){AdjustSize(205,gvGridtab9);}" />
                                            <Settings VerticalScrollBarMode="Auto" HorizontalScrollBarMode="Auto" />
                                            <SettingsBehavior ProcessFocusedRowChangedOnServer="false" />
                                        </dx:ASPxGridView>
                                          <div>
                                            <table style="width:40%;">
                                                <tr>
                                                    <td style="width: 6%;"><span style="font-size: 12px;">补收金额：</span></td>
                                                    <td style="width: 10%;">
                                                        <dx:ASPxTextBox runat="server" ID="txtJEtab9" Width="80%" Enabled="false" HorizontalAlign="Right" DisplayFormatString="0.00"></dx:ASPxTextBox>
                                                    </td>
                                                    <td style="width: 5%;">
                                                        <dx:ASPxLabel runat="server" ForeColor="Blue" ID="lbZongYeStab9" Text="共0条"></dx:ASPxLabel>
                                                    </td>
                                                </tr>
                                            </table>
                                        </div> 
                                    </dx:ContentControl>
                                </ContentCollection>
                            </dx:TabPage>
                        </TabPages>
                    </dx:ASPxPageControl>
                </div>
            </ContentTemplate>
        </asp:UpdatePanel>

        <div style="display: none;">
            <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server"></dx:ASPxGridViewExporter>
            <dx:ASPxButton ID="btnExport" runat="server" ClientInstanceName="btnExport" Text="导出EXCEL" OnClick="btnExport_Click" UseSubmitBehavior="false">
            </dx:ASPxButton>
        </div>
    </form>
</body>
</html>



